Tabela ContractServiceUnitType

Definicja tabeli ContractServiceUnitType

Name

ContractServiceUnitType

Code

ContractServiceUnitType

Comment

 


Lista kolumn tabeli ContractServiceUnitType

Name

Code

ContractServiceUnitTypeID

ContractServiceUnitTypeID

Active

Active

Code

Code

FullName

FullName

ShortName

ShortName

CostCalculation

CostCalculation


Kolumna ContractServiceUnitTypeID tabeli ContractServiceUnitType

Definicja kolumny ContractServiceUnitTypeID tabeli ContractServiceUnitType

Name

ContractServiceUnitTypeID

Code

ContractServiceUnitTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Active tabeli ContractServiceUnitType

Definicja kolumny Active tabeli ContractServiceUnitType

Name

Active

Code

Active

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna Code tabeli ContractServiceUnitType

Definicja kolumny Code tabeli ContractServiceUnitType

Name

Code

Code

Code

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna FullName tabeli ContractServiceUnitType

Definicja kolumny FullName tabeli ContractServiceUnitType

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna ShortName tabeli ContractServiceUnitType

Definicja kolumny ShortName tabeli ContractServiceUnitType

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(50)

Mandatory

No

Comment

 


Kolumna CostCalculation tabeli ContractServiceUnitType

Definicja kolumny CostCalculation tabeli ContractServiceUnitType

Name

CostCalculation

Code

CostCalculation

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Lista kluczy tabeli ContractServiceUnitType

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ContractServiceUnitType

Definicja klucza Identifier_1 tabeli ContractServiceUnitType

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment